package com.example.dzbsh.dao;

import com.example.dzbsh.model.ChaheQingkuang;
import com.example.dzbsh.model.ChaheQingkuangExample;
import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;

public interface ChaheQingkuangMapper {

    Object findWeiBnagdingCaheNum();

    Object findCaheNumByDeptIdList(@Param("deptidlist") List<String> ppDeptIdList);

    Object findWeiBnagdingCaheNumByDeptIdList(@Param("deptidlist") List<String> ppDeptIdList);

    List<Map<String,Object>> findCaheByDeptId(@Param("deptid") String ppDeptId);

    Object getCountByDeptIdAndJiashunameAndShifoubangding(@Param("deptid") String ppDeptId,@Param("jiashuname") String ppJiashuname,@Param("shifoubangding") String ppShifoubangding,
                                                          @Param("startindex") int ppStartIndex, @Param("pagesize") int ppPageSize);

    List<Map<String,Object>> findByDeptIdAndJiashunameAndShifoubangding(@Param("deptid") String ppDeptId, @Param("jiashuname") String ppJiashuname, @Param("shifoubangding") String ppShifoubangding,
                                                                        @Param("startindex") int ppStartIndex, @Param("pagesize") int ppPageSize);

    Object countByJiashuId(@Param("jiashuid")String ppJiashuId);

    int countByExample(ChaheQingkuangExample example);

    int deleteByExample(ChaheQingkuangExample example);

    int deleteByPrimaryKey(String id);

    int insert(ChaheQingkuang record);

    int insertSelective(ChaheQingkuang record);

    List<ChaheQingkuang> selectByExample(ChaheQingkuangExample example);

    ChaheQingkuang selectByPrimaryKey(String id);

    int updateByExampleSelective(@Param("record") ChaheQingkuang record, @Param("example") ChaheQingkuangExample example);

    int updateByExample(@Param("record") ChaheQingkuang record, @Param("example") ChaheQingkuangExample example);

    int updateByPrimaryKeySelective(ChaheQingkuang record);

    int updateByPrimaryKey(ChaheQingkuang record);
}